package com.lc.demo.mapper;

import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface RollMapper {

   /* @Select("select * from roll ")
    List<Roll> selectAllRoll();

    @Select("select * from roll  where  stunumber =#{stunumber}")
    List<Roll> findByStunumber(@Param("stunumber") String stunumber);


    @Insert("insert into roll (name,sex,nation,number , school,education, major,courts,clas,stunumber,status)" +
            "values(#{name},#{sex},#{nation},#{number},#{school},#{education},#{major},#{courts},#{clas},#{stunumber},#{status})")
    int addRoll(Roll roll);

    @Delete(" delete from roll where id=#{id} ")
    void deleteRollById(@Param("id") Integer id);

    @Select("select * from roll  where  id =#{id}")
    Roll selectById(@Param("id") int id);*/
}
